The SAS^® Markdown Optimization %TKMI_JOB_RO etl_end_service run with the option NIGHTLY=1 might generate the following messages in the MerchIntelGridSvr.log file:

YYYY-MM-DD HH:MM:SS,mmm [pool-n-thread-n] DEBUG - SQL: truncate table geo_prod_agg

YYYY-MM-DD HH:MM:SS,mmm [pool-n-thread-n] DEBUG - SQL: truncate table geo_prod_mts 

The workaround for this issue is to modify your nightly batch optimization process to save a copy of DI_DM2.GEO_PROD_AGG and DI_DM2.GEO_PROD_MTS to another location. Then after the %TKMI_JOB_RO etl_end_service completes copy the tables back to their original location. Afterward, be sure to run the Oracle maintenance job in order to regenerate the table statistics. Failure to do so might result in slower query performance.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Revenue Optimization 5.2 is available at:

A fix for this issue for SAS SizeOptimization 3.2 is available at: